{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Systeem","SjabloonVoorblad","SjabloonWerkproces","KerntakenEnWerkprocessen","Beheersingsniveaus","Voorblad","P6-K1-W3"],"not_rendered":{"macros":1,"defined_names":16,"comments":3},"read":"whole","date_system":"1900"}

{"sheet":"Systeem","index":0,"n_rows":21,"n_cols":3,"rows_kept":21,"hidden":true}
[]
[null,"Ja/Nee"]
[null,"Ja"]
[null,"Nee"]
[]
[null,"Debug modus"]
[null,0,"Normale bedrijfsstand =  0"]
[]
[null,"Teksten"]
[null,"Werkproces motivatie:","Doe dit volgens richtlijnen van de school. Het is raadzaam om in elk geval een onvoldoende te motiveren.\nBij de motivering kan gebruik gemaakt worden van de beschrijvingen in de beoordelingstabel.\n"]
[]
[null,"Fout markeer opmaak:"]
[]
[]
[null,"\"Grey-out\" opmaak:","greyed out"]
[]
[null,"Copyright tekst:","© Stichting Praktijkleren"]
[]
[null,"Regel afbreken werkprocesnaam:",45]
[]
[null,"Systeem versie:","30g"]

{"sheet":"SjabloonVoorblad","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"hidden":true,"merged":[[0,0,0,2],[2,0,2,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[11,1,11,2],[13,1,13,2]]}
["Beoordelingsformulier praktijkexamen"]
[]
["Algemene informatie"]
[]
["Code beoordelingsformulier en vaststellingsdatum","BF_MCS_BS22-PE22_P6-K1-W3_1",{"$f":"KerntakenEnWerkprocessen!B3","v":"2022-06-21"}]
["Examenvorm","[Examenvorm]"]
["Examennaam","[Examennaam]"]
["Examencode","[Examencode]"]
["Profiel","P6: Marketing & Communication Specialist, niveau 4"]
["Kwalificatiedossier","Business Services"]
["Cohort en crebocode","2022 en verder",25727]
["Kerntaak","Verzorgt marketing en (interne) communicatietrajecten"]
[]
["Werkprocessen","P6-K1-W3 Voert marktonderzoeken uit"]

{"sheet":"SjabloonWerkproces","index":2,"n_rows":19,"n_cols":4,"rows_kept":19,"hidden":true,"merged":[[9,1,9,6],[10,1,10,6],[12,1,12,6]]}
["Werkproces:",null,{"$f":"VLOOKUP(B1,werkprocessen,2,FALSE)","v":{"$error":"#N/A"}}]
["Eerste opdracht:",{"$f":"VLOOKUP(B1,KerntakenEnWerkprocessen!B13:E27,3,FALSE)","v":{"$error":"#N/A"}}]
["Laatste opdracht:",{"$f":"VLOOKUP(B1,KerntakenEnWerkprocessen!B13:E27,4,FALSE)","v":{"$error":"#N/A"}}]
["PuntentotaalMax",{"$f":"SUM(N:N)","v":0},"Invullen gestart:",{"$f":"IF(SUM(O:O)>0,TRUE,FALSE)","v":false}]
["PuntentotaalBehaald",{"$f":"SUM(M:M)","v":0}]
["#Ant. Mog. <=1",{"$f":"COUNTIF(N:N,1)","v":0}]
["#Ant. Mog. 2-3",{"$f":"COUNTIF(N:N,2)+COUNTIF(N:N,3)","v":0}]
["Cesuur",{"$f":"0.5*B4","v":0}]
[]
[null,"P6-K1-W3: Voert marktonderzoeken uit"]
[null,{"$f":"CONCATENATE(VLOOKUP(B1,werkprocessen,1,FALSE),\": \",C1)","v":{"$error":"#N/A"}}]
[]
[null,"Persoonsinformatie"]
[null,"Datum"]
[null,"Student"]
[null,"Studentnummer"]
[null,"Klas"]
[null,"Beoordelaar 1"]
[null,"Beoordelaar 2"]

{"sheet":"KerntakenEnWerkprocessen","index":3,"n_rows":29,"n_cols":6,"rows_kept":29,"hidden":true,"merged":[[3,1,3,2]]}
["Kerntaken en werkprocessen"]
[{"$nulls":5},{"$f":"F27","v":"P6-K1-W3 Voert marktonderzoeken uit\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n"}]
["Vaststellingsdatum","2022-06-21"]
["Code beoordelingsformulier","BF_BS22_P6-K1-W3_1"]
["Kerntaak",null,"Verzorgt marketing en (interne) communicatietrajecten"]
["Examenvorm",null,"[Examenvorm]"]
["Examennaam en Examencode","[Examennaam]","BS22_P6-K1-W3_1"]
["Kwalificatiedossier en Cohort","Business Services ","2022 en verder"]
["Profiel en crebocode","P6: Marketing & Communication Specialist, niveau 4",25727]
[]
[]
["Werkprocessen","Code","Naam","EersteOpdracht","LaatsteOpdracht","TekstSamengevoegd"]
[null,"P6-K1-W3","Voert marktonderzoeken uit",{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B13,Beheersingsniveaus!$B$4:$B$154))","v":1},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B13,Beheersingsniveaus!$B$4:$B$154))","v":2},{"$f":"B13&\" \"&C13&CHAR(10)","v":"P6-K1-W3 Voert marktonderzoeken uit\n"}]
[{"$nulls":3},{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B14,Beheersingsniveaus!$B$4:$B$154))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B14,Beheersingsniveaus!$B$4:$B$154))","v":0},{"$f":"F13&B14&\" \"&C14&CHAR(10)","v":"P6-K1-W3 Voert marktonderzoeken uit\n \n"}]
[{"$nulls":3},{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B15,Beheersingsniveaus!$B$4:$B$154))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B15,Beheersingsniveaus!$B$4:$B$154))","v":0},{"$f":"F14&B15&\" \"&C15&CHAR(10)","v":"P6-K1-W3 Voert marktonderzoeken uit\n \n \n"}]
[{"$nulls":3},{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B16,Beheersingsniveaus!$B$4:$B$154))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B16,Beheersingsniveaus!$B$4:$B$154))","v":0},"P6-K1-W3 Voert marktonderzoeken uit\n \n \n \n"]
[{"$nulls":3},{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B17,Beheersingsniveaus!$B$4:$B$154))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B17,Beheersingsniveaus!$B$4:$B$154))","v":0},"P6-K1-W3 Voert marktonderzoeken uit\n \n \n \n \n"]
[{"$nulls":3},{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B18,Beheersingsniveaus!$B$4:$B$154))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B18,Beheersingsniveaus!$B$4:$B$154))","v":0},"P6-K1-W3 Voert marktonderzoeken uit\n \n \n \n \n \n"]
[{"$nulls":3},{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B19,Beheersingsniveaus!$B$4:$B$154))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B19,Beheersingsniveaus!$B$4:$B$154))","v":0},"P6-K1-W3 Voert marktonderzoeken uit\n \n \n \n \n \n \n"]
[{"$nulls":3},{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B20,Beheersingsniveaus!$B$4:$B$154))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B20,Beheersingsniveaus!$B$4:$B$154))","v":0},"P6-K1-W3 Voert marktonderzoeken uit\n \n \n \n \n \n \n \n"]
[{"$nulls":3},{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B21,Beheersingsniveaus!$B$4:$B$154))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B21,Beheersingsniveaus!$B$4:$B$154))","v":0},"P6-K1-W3 Voert marktonderzoeken uit\n \n \n \n \n \n \n \n \n"]
[{"$nulls":3},{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B22,Beheersingsniveaus!$B$4:$B$154))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B22,Beheersingsniveaus!$B$4:$B$154))","v":0},"P6-K1-W3 Voert marktonderzoeken uit\n \n \n \n \n \n \n \n \n \n"]
[{"$nulls":3},{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B23,Beheersingsniveaus!$B$4:$B$154))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B23,Beheersingsniveaus!$B$4:$B$154))","v":0},{"$f":"F22&B23&\" \"&C23&CHAR(10)","v":"P6-K1-W3 Voert marktonderzoeken uit\n \n \n \n \n \n \n \n \n \n \n"}]
[{"$nulls":3},{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B24,Beheersingsniveaus!$B$4:$B$154))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B24,Beheersingsniveaus!$B$4:$B$154))","v":0},"P6-K1-W3 Voert marktonderzoeken uit\n \n \n \n \n \n \n \n \n \n \n \n"]
[{"$nulls":3},{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B25,Beheersingsniveaus!$B$4:$B$154))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B25,Beheersingsniveaus!$B$4:$B$154))","v":0},"P6-K1-W3 Voert marktonderzoeken uit\n \n \n \n \n \n \n \n \n \n \n \n \n"]
[{"$nulls":3},{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B26,Beheersingsniveaus!$B$4:$B$154))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B26,Beheersingsniveaus!$B$4:$B$154))","v":0},"P6-K1-W3 Voert marktonderzoeken uit\n \n \n \n \n \n \n \n \n \n \n \n \n \n"]
[{"$nulls":3},{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B27,Beheersingsniveaus!$B$4:$B$154))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$154=KerntakenEnWerkprocessen!$B27,Beheersingsniveaus!$B$4:$B$154))","v":0},"P6-K1-W3 Voert marktonderzoeken uit\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n"]
[]
["Handtekening kandidaat tonen:",null,null,false]

{"sheet":"Beheersingsniveaus","index":4,"n_rows":154,"n_cols":11,"rows_kept":154,"hidden":true}
["Beschrijvingen beheersingsniveaus"]
[]
["Werkproces","Opdracht","OpdrachtId","CriteriumId","Taken","Criterium","Beheersingsniveau 0","Beheersingsniveau 1","Beheersingsniveau 2","Beheersingsniveau 3","Cruciaal"]
["P6-K1-W3",1,{"$f":"IF(A4<>\"\",CONCATENATE(A4,\"-\",B4),\"\")","v":"P6-K1-W3-1"},{"$f":"IF(C4<>\"\",CONCATENATE(C4,\"-\",\"1\"),\"\")","v":"P6-K1-W3-1-1"},"T1","Volledigheid inhoud onderzoeks-\nvoorstel","De informatie in het onderzoeksvoorstel sluit niet aan op de onderzoeksvraag.","De informatie in het onderzoeksvoorstel sluit deels aan op de onderzoeksvraag, maar niet op cruciale punten.","De informatie in het onderzoeksvoorstel sluit deels aan op de onderzoeksvraag, maar wel op cruciale punten.","De informatie in het onderzoeksvoorstel sluit volledig aan op de onderzoeksvraag."]
["P6-K1-W3",1,{"$f":"IF(A5<>\"\",CONCATENATE(A5,\"-\",B5),\"\")","v":"P6-K1-W3-1"},{"$f":"IF(C5<>\"\",CONCATENATE(C5,\"-\",COUNTIF($C$4:C5,C5),\"\"),\"\")","v":"P6-K1-W3-1-2"},"T1","Haalbaarheid onderzoeks-\nvoorstel","Het onderzoeksvoorstel is onhaalbaar, gelet op het beschikbare budget.","Het onderzoeksvoorstel is haalbaar, gelet op het beschikbare budget."]
["P6-K1-W3",1,"P6-K1-W3-1",{"$f":"IF(C6<>\"\",CONCATENATE(C6,\"-\",COUNTIF($C$4:C6,C6),\"\"),\"\")","v":"P6-K1-W3-1-3"},"T2","Relevantie onderzoeksvragen","De uitgewerkte onderzoeksvragen zijn niet relevant.","De uitgewerkte onderzoeksvragen zijn in beperkte mate relevant.","De uitgewerkte onderzoeksvragen zijn grotendeels relevant.","Alle uitgewerkte onderzoeksvragen zijn volledig relevant."]
["P6-K1-W3",2,"P6-K1-W3-2",{"$f":"IF(C7<>\"\",CONCATENATE(C7,\"-\",COUNTIF($C$4:C7,C7),\"\"),\"\")","v":"P6-K1-W3-2-1"},"T3","Kwaliteit gebruikte bronnen","De gebruikte bronnen zijn niet:\n\n- actueel\n- betrouwbaar\n- relevant/passend","De gebruikte bronnen zijn in beperkte mate:\n\n Zie beheersingslijst 0.","De gebruikte bronnen zijn grotendeels:\n\n Zie beheersingslijst 0.","De gebruikte  bronnen zijn volledig:\n\nZie beheersingslijst 0."]
["P6-K1-W3",2,"P6-K1-W3-2",{"$f":"IF(C8<>\"\",CONCATENATE(C8,\"-\",COUNTIF($C$4:C8,C8),\"\"),\"\")","v":"P6-K1-W3-2-2"},"T4","Relevantie conclusies en aanbevelingen","Conclusies en aanbevelingen sluiten niet aan bij de probleemstelling en deelvragen.","Conclusies en aanbevelingen sluiten deels aan bij de probleemstelling en deelvragen, maar niet op cruciale punten.","Conclusies en aanbevelingen sluiten deels aan bij de probleemstelling en deelvragen, maar wel op cruciale punten.","Conclusies en aanbevelingen sluiten volledig aan bij de probleemstelling en deelvragen."]
["P6-K1-W3",2,"P6-K1-W3-2",{"$f":"IF(C9<>\"\",CONCATENATE(C9,\"-\",COUNTIF($C$4:C9,C9),\"\"),\"\")","v":"P6-K1-W3-2-3"},"T4","Accuratie tabellen en grafieken","De resultaten zijn grafisch niet:\n\n- duidelijk\n- overzichtelijk\n  weergegeven","De resultaten zijn grafisch grotendeels:\n\nZie beheersingslijst 0.","De resultaten zijn grafisch, op enkele details na:\n\nZie beheersingslijst 0.","Alle resultaten zijn grafisch:\n\nZie beheersingslijst 0."]
["P6-K1-W3",2,"P6-K1-W3-2",{"$f":"IF(C10<>\"\",CONCATENATE(C10,\"-\",COUNTIF($C$4:C10,C10),\"\"),\"\")","v":"P6-K1-W3-2-4"},"T5","Volledigheid onderzoeks-\nrapport","De informatie in het onderzoeksrapport is onvolledig.","De informatie in het onderzoeksrapport is op meerdere punten onvolledig.","De informatie in het onderzoeksrapport is op enkele details na volledig.","De informatie in het onderzoeksrapport is volledig."]
["P6-K1-W3",2,"P6-K1-W3-2",{"$f":"IF(C11<>\"\",CONCATENATE(C11,\"-\",COUNTIF($C$4:C11,C11),\"\"),\"\")","v":"P6-K1-W3-2-5"},"T5","Taalkundige correctheid","De rapportage is niet correct:\n\n- qua zinsbouw\n- spelling\n- grammatica","De rapportage is in beperkte mate correct:\n\nZie beheersingslijst 0.\n\n ","De rapportage is grotendeels correct:\n\nZie beheersingslijst 0.\n\n","De rapportage is volledig correct:\n\nZie beheersingslijst 0.\n\n"]
["P6-K1-W3",2,"P6-K1-W3-2",{"$f":"IF(C12<>\"\",CONCATENATE(C12,\"-\",COUNTIF($C$4:C12,C12),\"\"),\"\")","v":"P6-K1-W3-2-6"},"T5","Structuur onderzoeks-\nrapport","De informatie is niet gestructureerd (huisstijl en procedures) volgens het model van de organisatie of het format.","De informatie is op meerdere punten niet gestructureerd (huisstijl en procedures) volgens het model van de organisatie of het format.","De informatie is op enkele details na gestructureerd (huisstijl en procedures) volgens het model van de organisatie of het format.","De informatie is volledig gestructureerd (huisstijl en procedures) volgens het model van de organisatie of het format."]
["P6-K1-W3",2,"P6-K1-W3-2",{"$f":"IF(C13<>\"\",CONCATENATE(C13,\"-\",COUNTIF($C$4:C13,C13),\"\"),\"\")","v":"P6-K1-W3-2-7"},"T6","Duidelijkheid presentatie","Het rapport is niet kernachtig en niet duidelijk gepresenteerd.","Het rapport is enigszins kernachtig en niet duidelijk gepresenteerd.","Het rapport is grotendeels kernachtig en duidelijk gepresenteerd.","Het rapport is volledig kernachtig en duidelijk gepresenteerd."]
[null,null,"",{"$f":"IF(C14<>\"\",CONCATENATE(C14,\"-\",COUNTIF($C$4:C14,C14),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C15<>\"\",CONCATENATE(C15,\"-\",COUNTIF($C$4:C15,C15),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C16<>\"\",CONCATENATE(C16,\"-\",COUNTIF($C$4:C16,C16),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C17<>\"\",CONCATENATE(C17,\"-\",COUNTIF($C$4:C17,C17),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C18<>\"\",CONCATENATE(C18,\"-\",COUNTIF($C$4:C18,C18),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C19<>\"\",CONCATENATE(C19,\"-\",COUNTIF($C$4:C19,C19),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C20<>\"\",CONCATENATE(C20,\"-\",COUNTIF($C$4:C20,C20),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C21<>\"\",CONCATENATE(C21,\"-\",COUNTIF($C$4:C21,C21),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C22<>\"\",CONCATENATE(C22,\"-\",COUNTIF($C$4:C22,C22),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C23<>\"\",CONCATENATE(C23,\"-\",COUNTIF($C$4:C23,C23),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C24<>\"\",CONCATENATE(C24,\"-\",COUNTIF($C$4:C24,C24),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C25<>\"\",CONCATENATE(C25,\"-\",COUNTIF($C$4:C25,C25),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C26<>\"\",CONCATENATE(C26,\"-\",COUNTIF($C$4:C26,C26),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C27<>\"\",CONCATENATE(C27,\"-\",COUNTIF($C$4:C27,C27),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C28<>\"\",CONCATENATE(C28,\"-\",COUNTIF($C$4:C28,C28),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C29<>\"\",CONCATENATE(C29,\"-\",COUNTIF($C$4:C29,C29),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C30<>\"\",CONCATENATE(C30,\"-\",COUNTIF($C$4:C30,C30),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C31<>\"\",CONCATENATE(C31,\"-\",COUNTIF($C$4:C31,C31),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C32<>\"\",CONCATENATE(C32,\"-\",COUNTIF($C$4:C32,C32),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C33<>\"\",CONCATENATE(C33,\"-\",COUNTIF($C$4:C33,C33),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C34<>\"\",CONCATENATE(C34,\"-\",COUNTIF($C$4:C34,C34),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C35<>\"\",CONCATENATE(C35,\"-\",COUNTIF($C$4:C35,C35),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C36<>\"\",CONCATENATE(C36,\"-\",COUNTIF($C$4:C36,C36),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C37<>\"\",CONCATENATE(C37,\"-\",COUNTIF($C$4:C37,C37),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C38<>\"\",CONCATENATE(C38,\"-\",COUNTIF($C$4:C38,C38),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C39<>\"\",CONCATENATE(C39,\"-\",COUNTIF($C$4:C39,C39),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C40<>\"\",CONCATENATE(C40,\"-\",COUNTIF($C$4:C40,C40),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C41<>\"\",CONCATENATE(C41,\"-\",COUNTIF($C$4:C41,C41),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C42<>\"\",CONCATENATE(C42,\"-\",COUNTIF($C$4:C42,C42),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C43<>\"\",CONCATENATE(C43,\"-\",COUNTIF($C$4:C43,C43),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C44<>\"\",CONCATENATE(C44,\"-\",COUNTIF($C$4:C44,C44),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C45<>\"\",CONCATENATE(C45,\"-\",COUNTIF($C$4:C45,C45),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C46<>\"\",CONCATENATE(C46,\"-\",COUNTIF($C$4:C46,C46),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C47<>\"\",CONCATENATE(C47,\"-\",COUNTIF($C$4:C47,C47),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C48<>\"\",CONCATENATE(C48,\"-\",COUNTIF($C$4:C48,C48),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C49<>\"\",CONCATENATE(C49,\"-\",COUNTIF($C$4:C49,C49),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C50<>\"\",CONCATENATE(C50,\"-\",COUNTIF($C$4:C50,C50),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C51<>\"\",CONCATENATE(C51,\"-\",COUNTIF($C$4:C51,C51),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C52<>\"\",CONCATENATE(C52,\"-\",COUNTIF($C$4:C52,C52),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C53<>\"\",CONCATENATE(C53,\"-\",COUNTIF($C$4:C53,C53),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C54<>\"\",CONCATENATE(C54,\"-\",COUNTIF($C$4:C54,C54),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C55<>\"\",CONCATENATE(C55,\"-\",COUNTIF($C$4:C55,C55),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C56<>\"\",CONCATENATE(C56,\"-\",COUNTIF($C$4:C56,C56),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C57<>\"\",CONCATENATE(C57,\"-\",COUNTIF($C$4:C57,C57),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C58<>\"\",CONCATENATE(C58,\"-\",COUNTIF($C$4:C58,C58),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C59<>\"\",CONCATENATE(C59,\"-\",COUNTIF($C$4:C59,C59),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C60<>\"\",CONCATENATE(C60,\"-\",COUNTIF($C$4:C60,C60),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C61<>\"\",CONCATENATE(C61,\"-\",COUNTIF($C$4:C61,C61),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C62<>\"\",CONCATENATE(C62,\"-\",COUNTIF($C$4:C62,C62),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C63<>\"\",CONCATENATE(C63,\"-\",COUNTIF($C$4:C63,C63),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C64<>\"\",CONCATENATE(C64,\"-\",COUNTIF($C$4:C64,C64),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C65<>\"\",CONCATENATE(C65,\"-\",COUNTIF($C$4:C65,C65),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C66<>\"\",CONCATENATE(C66,\"-\",COUNTIF($C$4:C66,C66),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C67<>\"\",CONCATENATE(C67,\"-\",COUNTIF($C$4:C67,C67),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C68<>\"\",CONCATENATE(C68,\"-\",COUNTIF($C$4:C68,C68),\"\"),\"\")","v":""}]
[null,null,{"$f":"IF(A69<>\"\",CONCATENATE(A69,\"-\",B69),\"\")","v":""},{"$f":"IF(C69<>\"\",CONCATENATE(C69,\"-\",COUNTIF($C$4:C69,C69),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C70<>\"\",CONCATENATE(C70,\"-\",COUNTIF($C$4:C70,C70),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C71<>\"\",CONCATENATE(C71,\"-\",COUNTIF($C$4:C71,C71),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C72<>\"\",CONCATENATE(C72,\"-\",COUNTIF($C$4:C72,C72),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C73<>\"\",CONCATENATE(C73,\"-\",COUNTIF($C$4:C73,C73),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C74<>\"\",CONCATENATE(C74,\"-\",COUNTIF($C$4:C74,C74),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C75<>\"\",CONCATENATE(C75,\"-\",COUNTIF($C$4:C75,C75),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C76<>\"\",CONCATENATE(C76,\"-\",COUNTIF($C$4:C76,C76),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C77<>\"\",CONCATENATE(C77,\"-\",COUNTIF($C$4:C77,C77),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C78<>\"\",CONCATENATE(C78,\"-\",COUNTIF($C$4:C78,C78),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C79<>\"\",CONCATENATE(C79,\"-\",COUNTIF($C$4:C79,C79),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C80<>\"\",CONCATENATE(C80,\"-\",COUNTIF($C$4:C80,C80),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C81<>\"\",CONCATENATE(C81,\"-\",COUNTIF($C$4:C81,C81),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C82<>\"\",CONCATENATE(C82,\"-\",COUNTIF($C$4:C82,C82),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C83<>\"\",CONCATENATE(C83,\"-\",COUNTIF($C$4:C83,C83),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C84<>\"\",CONCATENATE(C84,\"-\",COUNTIF($C$4:C84,C84),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C85<>\"\",CONCATENATE(C85,\"-\",COUNTIF($C$4:C85,C85),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C86<>\"\",CONCATENATE(C86,\"-\",COUNTIF($C$4:C86,C86),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C87<>\"\",CONCATENATE(C87,\"-\",COUNTIF($C$4:C87,C87),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C88<>\"\",CONCATENATE(C88,\"-\",COUNTIF($C$4:C88,C88),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C89<>\"\",CONCATENATE(C89,\"-\",COUNTIF($C$4:C89,C89),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C90<>\"\",CONCATENATE(C90,\"-\",COUNTIF($C$4:C90,C90),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C91<>\"\",CONCATENATE(C91,\"-\",COUNTIF($C$4:C91,C91),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C92<>\"\",CONCATENATE(C92,\"-\",COUNTIF($C$4:C92,C92),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C93<>\"\",CONCATENATE(C93,\"-\",COUNTIF($C$4:C93,C93),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C94<>\"\",CONCATENATE(C94,\"-\",COUNTIF($C$4:C94,C94),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C95<>\"\",CONCATENATE(C95,\"-\",COUNTIF($C$4:C95,C95),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C96<>\"\",CONCATENATE(C96,\"-\",COUNTIF($C$4:C96,C96),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C97<>\"\",CONCATENATE(C97,\"-\",COUNTIF($C$4:C97,C97),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C98<>\"\",CONCATENATE(C98,\"-\",COUNTIF($C$4:C98,C98),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C99<>\"\",CONCATENATE(C99,\"-\",COUNTIF($C$4:C99,C99),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C100<>\"\",CONCATENATE(C100,\"-\",COUNTIF($C$4:C100,C100),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C101<>\"\",CONCATENATE(C101,\"-\",COUNTIF($C$4:C101,C101),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C102<>\"\",CONCATENATE(C102,\"-\",COUNTIF($C$4:C102,C102),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C103<>\"\",CONCATENATE(C103,\"-\",COUNTIF($C$4:C103,C103),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C104<>\"\",CONCATENATE(C104,\"-\",COUNTIF($C$4:C104,C104),\"\"),\"\")","v":""}]
[null,null,{"$f":"IF(A105<>\"\",CONCATENATE(A105,\"-\",B105),\"\")","v":""},{"$f":"IF(C105<>\"\",CONCATENATE(C105,\"-\",COUNTIF($C$4:C105,C105),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C106<>\"\",CONCATENATE(C106,\"-\",COUNTIF($C$4:C106,C106),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C107<>\"\",CONCATENATE(C107,\"-\",COUNTIF($C$4:C107,C107),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C108<>\"\",CONCATENATE(C108,\"-\",COUNTIF($C$4:C108,C108),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C109<>\"\",CONCATENATE(C109,\"-\",COUNTIF($C$4:C109,C109),\"\"),\"\")","v":""}]
[null,null,{"$f":"IF(A110<>\"\",CONCATENATE(A110,\"-\",B110),\"\")","v":""},{"$f":"IF(C110<>\"\",CONCATENATE(C110,\"-\",COUNTIF($C$4:C110,C110),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C111<>\"\",CONCATENATE(C111,\"-\",COUNTIF($C$4:C111,C111),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C112<>\"\",CONCATENATE(C112,\"-\",COUNTIF($C$4:C112,C112),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C113<>\"\",CONCATENATE(C113,\"-\",COUNTIF($C$4:C113,C113),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C114<>\"\",CONCATENATE(C114,\"-\",COUNTIF($C$4:C114,C114),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C115<>\"\",CONCATENATE(C115,\"-\",COUNTIF($C$4:C115,C115),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C116<>\"\",CONCATENATE(C116,\"-\",COUNTIF($C$4:C116,C116),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C117<>\"\",CONCATENATE(C117,\"-\",COUNTIF($C$4:C117,C117),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C118<>\"\",CONCATENATE(C118,\"-\",COUNTIF($C$4:C118,C118),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C119<>\"\",CONCATENATE(C119,\"-\",COUNTIF($C$4:C119,C119),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C120<>\"\",CONCATENATE(C120,\"-\",COUNTIF($C$4:C120,C120),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C121<>\"\",CONCATENATE(C121,\"-\",COUNTIF($C$4:C121,C121),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C122<>\"\",CONCATENATE(C122,\"-\",COUNTIF($C$4:C122,C122),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C123<>\"\",CONCATENATE(C123,\"-\",COUNTIF($C$4:C123,C123),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C124<>\"\",CONCATENATE(C124,\"-\",COUNTIF($C$4:C124,C124),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C125<>\"\",CONCATENATE(C125,\"-\",COUNTIF($C$4:C125,C125),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C126<>\"\",CONCATENATE(C126,\"-\",COUNTIF($C$4:C126,C126),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C127<>\"\",CONCATENATE(C127,\"-\",COUNTIF($C$4:C127,C127),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C128<>\"\",CONCATENATE(C128,\"-\",COUNTIF($C$4:C128,C128),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C129<>\"\",CONCATENATE(C129,\"-\",COUNTIF($C$4:C129,C129),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C130<>\"\",CONCATENATE(C130,\"-\",COUNTIF($C$4:C130,C130),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C131<>\"\",CONCATENATE(C131,\"-\",COUNTIF($C$4:C131,C131),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C132<>\"\",CONCATENATE(C132,\"-\",COUNTIF($C$4:C132,C132),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C133<>\"\",CONCATENATE(C133,\"-\",COUNTIF($C$4:C133,C133),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C134<>\"\",CONCATENATE(C134,\"-\",COUNTIF($C$4:C134,C134),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C135<>\"\",CONCATENATE(C135,\"-\",COUNTIF($C$4:C135,C135),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C136<>\"\",CONCATENATE(C136,\"-\",COUNTIF($C$4:C136,C136),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C137<>\"\",CONCATENATE(C137,\"-\",COUNTIF($C$4:C137,C137),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C138<>\"\",CONCATENATE(C138,\"-\",COUNTIF($C$4:C138,C138),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C139<>\"\",CONCATENATE(C139,\"-\",COUNTIF($C$4:C139,C139),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C140<>\"\",CONCATENATE(C140,\"-\",COUNTIF($C$4:C140,C140),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C141<>\"\",CONCATENATE(C141,\"-\",COUNTIF($C$4:C141,C141),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C142<>\"\",CONCATENATE(C142,\"-\",COUNTIF($C$4:C142,C142),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C143<>\"\",CONCATENATE(C143,\"-\",COUNTIF($C$4:C143,C143),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C144<>\"\",CONCATENATE(C144,\"-\",COUNTIF($C$4:C144,C144),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C145<>\"\",CONCATENATE(C145,\"-\",COUNTIF($C$4:C145,C145),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C146<>\"\",CONCATENATE(C146,\"-\",COUNTIF($C$4:C146,C146),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C147<>\"\",CONCATENATE(C147,\"-\",COUNTIF($C$4:C147,C147),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C148<>\"\",CONCATENATE(C148,\"-\",COUNTIF($C$4:C148,C148),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C149<>\"\",CONCATENATE(C149,\"-\",COUNTIF($C$4:C149,C149),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C150<>\"\",CONCATENATE(C150,\"-\",COUNTIF($C$4:C150,C150),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C151<>\"\",CONCATENATE(C151,\"-\",COUNTIF($C$4:C151,C151),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C152<>\"\",CONCATENATE(C152,\"-\",COUNTIF($C$4:C152,C152),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C153<>\"\",CONCATENATE(C153,\"-\",COUNTIF($C$4:C153,C153),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C154<>\"\",CONCATENATE(C154,\"-\",COUNTIF($C$4:C154,C154),\"\"),\"\")","v":""}]

{"sheet":"Voorblad","index":5,"n_rows":27,"n_cols":4,"rows_kept":27,"merged":[[0,0,0,2],[2,0,2,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[11,1,11,2],[13,1,13,2],[15,0,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[23,2,24,2]]}
["Beoordelingsformulier praktijkexamen"]
[]
["Algemene informatie"]
[]
["Code beoordelingsformulier en vaststellingsdatum","BF_MCS_BS22_P6-K1-W3_1",{"$f":"KerntakenEnWerkprocessen!B3","v":"2022-06-21"}]
["Examenvorm","Praktijkexamen"]
["Examennaam","[Examennaam]"]
["Examencode","MCS_BS22-PE22_P6-K1-W3_1"]
["Profiel","P6: Marketing & Communication Specialist, niveau 4"]
["Kwalificatiedossier","Business Services"]
["Cohort en crebocode","2022 en verder",25727]
["Kerntaak","Verzorgt marketing en (interne) communicatietrajecten"]
[]
["Werkprocessen","P6-K1-W3 Voert marktonderzoeken uit"]
[]
["Persoonsinformatie"]
["Datum",null,null," [Vul alleen de groene cellen in]"]
["Student"]
["Studentnummer"]
["Klas"]
["Beoordelaar 1"]
["Beoordelaar 2"]
[]
["Werkprocessen","Resultaat","[Laat de rode cellen leeg. Excel vult het resultaat automatisch in na beoordeling van de werkprocessen.]"]
["P6-K1-W3",{"$f":"'P6-K1-W3'!B71","v":""}]
[]
["Handtekening beoordelaar 1","Handtekening beoordelaar 2"]

{"sheet":"P6-K1-W3","index":6,"n_rows":80,"n_cols":15,"rows_kept":80,"merged":[[9,1,9,6],[10,1,10,6],[12,1,12,6],[20,1,20,6],[27,1,27,6],[38,1,38,6],[74,1,74,6],[75,1,75,6]]}
["Werkproces:","P6-K1-W3",{"$f":"VLOOKUP(B1,werkprocessen,2,FALSE)","v":"Voert marktonderzoeken uit"}]
["Eerste opdracht:",{"$f":"VLOOKUP(B1,KerntakenEnWerkprocessen!B13:E27,3,FALSE)","v":1}]
["Laatste opdracht:",{"$f":"VLOOKUP(B1,KerntakenEnWerkprocessen!B13:E27,4,FALSE)","v":2}]
["PuntentotaalMax",{"$f":"SUM(N:N)","v":28},"Invullen gestart:",{"$f":"IF(SUM(O:O)>0,TRUE,FALSE)","v":true}]
["PuntentotaalBehaald",{"$f":"SUM(M:M)","v":0}]
["#Ant. Mog. <=1",{"$f":"COUNTIF(N:N,1)","v":1}]
["#Ant. Mog. 2-3",{"$f":"COUNTIF(N:N,2)+COUNTIF(N:N,3)","v":9}]
["Cesuur",{"$f":"0.5*B4","v":14}]
[]
[null,"P6-K1-W3: Voert marktonderzoeken uit"]
[null,{"$f":"CONCATENATE(VLOOKUP(B1,werkprocessen,1,FALSE),\": \",C1)","v":"P6-K1-W3: Voert marktonderzoeken uit"}]
[]
[null,"Persoonsinformatie"]
[null,"Datum",{"$f":"IF(Voorblad!B17=\"\",\"\",Voorblad!B17)","v":""}]
[null,"Student",{"$f":"IF(Voorblad!B18=\"\",\"\",Voorblad!B18)","v":""}]
[null,"Studentnummer",{"$f":"IF(Voorblad!B19=\"\",\"\",Voorblad!B19)","v":""}]
[null,"Klas",{"$f":"IF(Voorblad!B20=\"\",\"\",Voorblad!B20)","v":""}]
[null,"Beoordelaar 1",{"$f":"IF(Voorblad!B21=\"\",\"\",Voorblad!B21)","v":""}]
[null,"Beoordelaar 2",{"$f":"IF(Voorblad!B22=\"\",\"\",Voorblad!B22)","v":""}]
[]
[null,"Beoordeling opdracht 1"]
["Opdracht:",1,null,"OpdrachtId:","P6-K1-W3-1",null,"Aantal criteria:",{"$f":"COUNTIF(Beheersingsniveaus!$C$4:$C$154,$E22)","v":3}]
["CriteriumId","Taak","Criterium",0,1,2,3,"Cruciaal","Cb0","Cb1","Cb2","Cb3","PuntentotaalBehaald","PuntentotaalMax","CheckboxenIngevuld"]
["P6-K1-W3-1-1",{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T1"},{"$f":"CONCATENATE(VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H24=ja,\"*\",\"\"))","v":"Volledigheid inhoud onderzoeks-\nvoorstel"},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"De informatie in het onderzoeksvoorstel sluit niet aan op de onderzoeksvraag."},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"De informatie in het onderzoeksvoorstel sluit deels aan op de onderzoeksvraag, maar niet op cruciale punten."},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"De informatie in het onderzoeksvoorstel sluit deels aan op de onderzoeksvraag, maar wel op cruciale punten."},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"De informatie in het onderzoeksvoorstel sluit volledig aan op de onderzoeksvraag."},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,false,false,{"$f":"IF(L24=TRUE,3,IF(K24=TRUE,2,IF(J24=TRUE,1,IF(I24=TRUE,0,0))))","v":0},{"$f":"(4-COUNTBLANK(D24:G24))-1","v":3},{"$f":"COUNTA(I24:L24)","v":2}]
["P6-K1-W3-1-2",{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T1"},{"$f":"CONCATENATE(VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H25=ja,\"*\",\"\"))","v":"Haalbaarheid onderzoeks-\nvoorstel"},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Het onderzoeksvoorstel is onhaalbaar, gelet op het beschikbare budget."},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Het onderzoeksvoorstel is haalbaar, gelet op het beschikbare budget."},null,null,{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},{"$nulls":4},{"$f":"IF(L25=TRUE,3,IF(K25=TRUE,2,IF(J25=TRUE,1,IF(I25=TRUE,0,0))))","v":0},{"$f":"(4-COUNTBLANK(D25:G25))-1","v":1},{"$f":"COUNTA(I25:L25)","v":0}]
["P6-K1-W3-1-3",{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T2"},{"$f":"CONCATENATE(VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H26=ja,\"*\",\"\"))","v":"Relevantie onderzoeksvragen"},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"De uitgewerkte onderzoeksvragen zijn niet relevant."},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"De uitgewerkte onderzoeksvragen zijn in beperkte mate relevant."},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"De uitgewerkte onderzoeksvragen zijn grotendeels relevant."},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Alle uitgewerkte onderzoeksvragen zijn volledig relevant."},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},{"$nulls":3},false,{"$f":"IF(L26=TRUE,3,IF(K26=TRUE,2,IF(J26=TRUE,1,IF(I26=TRUE,0,0))))","v":0},{"$f":"(4-COUNTBLANK(D26:G26))-1","v":3},{"$f":"COUNTA(I26:L26)","v":1}]
[]
[null,"Beoordeling opdracht 2"]
["Opdracht:",2,null,"OpdrachtId:","P6-K1-W3-2",null,"Aantal criteria:",{"$f":"COUNTIF(Beheersingsniveaus!$C$4:$C$154,$E29)","v":7}]
["CriteriumId","Taak","Criterium",0,1,2,3,"Cruciaal","Cb0","Cb1","Cb2","Cb3","PuntentotaalBehaald","PuntentotaalMax","CheckboxenIngevuld"]
["P6-K1-W3-2-1",{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T3"},{"$f":"CONCATENATE(VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H31=ja,\"*\",\"\"))","v":"Kwaliteit gebruikte bronnen"},{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"De gebruikte bronnen zijn niet:\n\n- actueel\n- betrouwbaar\n- relevant/passend"},{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"De gebruikte bronnen zijn in beperkte mate:\n\n Zie beheersingslijst 0."},{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"De gebruikte bronnen zijn grotendeels:\n\n Zie beheersingslijst 0."},{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"De gebruikte  bronnen zijn volledig:\n\nZie beheersingslijst 0."},{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},{"$nulls":4},{"$f":"IF(L31=TRUE,3,IF(K31=TRUE,2,IF(J31=TRUE,1,IF(I31=TRUE,0,0))))","v":0},{"$f":"(4-COUNTBLANK(D31:G31))-1","v":3},{"$f":"COUNTA(I31:L31)","v":0}]
["P6-K1-W3-2-2",{"$f":"VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T4"},{"$f":"CONCATENATE(VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H32=ja,\"*\",\"\"))","v":"Relevantie conclusies en aanbevelingen"},{"$f":"VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Conclusies en aanbevelingen sluiten niet aan bij de probleemstelling en deelvragen."},{"$f":"VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Conclusies en aanbevelingen sluiten deels aan bij de probleemstelling en deelvragen, maar niet op cruciale punten."},{"$f":"VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Conclusies en aanbevelingen sluiten deels aan bij de probleemstelling en deelvragen, maar wel op cruciale punten."},{"$f":"VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Conclusies en aanbevelingen sluiten volledig aan bij de probleemstelling en deelvragen."},{"$f":"VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},{"$nulls":4},0,3,0]
["P6-K1-W3-2-3",{"$f":"VLOOKUP($A33,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T4"},{"$f":"CONCATENATE(VLOOKUP($A33,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H33=ja,\"*\",\"\"))","v":"Accuratie tabellen en grafieken"},{"$f":"VLOOKUP($A33,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"De resultaten zijn grafisch niet:\n\n- duidelijk\n- overzichtelijk\n  weergegeven"},{"$f":"VLOOKUP($A33,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"De resultaten zijn grafisch grotendeels:\n\nZie beheersingslijst 0."},{"$f":"VLOOKUP($A33,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"De resultaten zijn grafisch, op enkele details na:\n\nZie beheersingslijst 0."},{"$f":"VLOOKUP($A33,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Alle resultaten zijn grafisch:\n\nZie beheersingslijst 0."},{"$f":"VLOOKUP($A33,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},{"$nulls":4},0,3,0]
["P6-K1-W3-2-4",{"$f":"VLOOKUP($A34,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T5"},{"$f":"CONCATENATE(VLOOKUP($A34,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H34=ja,\"*\",\"\"))","v":"Volledigheid onderzoeks-\nrapport"},{"$f":"VLOOKUP($A34,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"De informatie in het onderzoeksrapport is onvolledig."},{"$f":"VLOOKUP($A34,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"De informatie in het onderzoeksrapport is op meerdere punten onvolledig."},{"$f":"VLOOKUP($A34,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"De informatie in het onderzoeksrapport is op enkele details na volledig."},{"$f":"VLOOKUP($A34,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"De informatie in het onderzoeksrapport is volledig."},{"$f":"VLOOKUP($A34,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},{"$nulls":4},0,3,0]
["P6-K1-W3-2-5",{"$f":"VLOOKUP($A35,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T5"},{"$f":"CONCATENATE(VLOOKUP($A35,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H35=ja,\"*\",\"\"))","v":"Taalkundige correctheid"},{"$f":"VLOOKUP($A35,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"De rapportage is niet correct:\n\n- qua zinsbouw\n- spelling\n- grammatica"},{"$f":"VLOOKUP($A35,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"De rapportage is in beperkte mate correct:\n\nZie beheersingslijst 0.\n\n "},{"$f":"VLOOKUP($A35,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"De rapportage is grotendeels correct:\n\nZie beheersingslijst 0.\n\n"},{"$f":"VLOOKUP($A35,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"De rapportage is volledig correct:\n\nZie beheersingslijst 0.\n\n"},{"$f":"VLOOKUP($A35,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},{"$nulls":3},false,0,3,1]
["P6-K1-W3-2-6",{"$f":"VLOOKUP($A36,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T5"},{"$f":"CONCATENATE(VLOOKUP($A36,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H36=ja,\"*\",\"\"))","v":"Structuur onderzoeks-\nrapport"},{"$f":"VLOOKUP($A36,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"De informatie is niet gestructureerd (huisstijl en procedures) volgens het model van de organisatie of het format."},{"$f":"VLOOKUP($A36,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"De informatie is op meerdere punten niet gestructureerd (huisstijl en procedures) volgens het model van de organisatie of het format."},{"$f":"VLOOKUP($A36,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"De informatie is op enkele details na gestructureerd (huisstijl en procedures) volgens het model van de organisatie of het format."},{"$f":"VLOOKUP($A36,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"De informatie is volledig gestructureerd (huisstijl en procedures) volgens het model van de organisatie of het format."},{"$f":"VLOOKUP($A36,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},{"$nulls":3},false,0,3,1]
["P6-K1-W3-2-7",{"$f":"VLOOKUP($A37,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T6"},{"$f":"CONCATENATE(VLOOKUP($A37,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H37=ja,\"*\",\"\"))","v":"Duidelijkheid presentatie"},{"$f":"VLOOKUP($A37,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Het rapport is niet kernachtig en niet duidelijk gepresenteerd."},{"$f":"VLOOKUP($A37,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Het rapport is enigszins kernachtig en niet duidelijk gepresenteerd."},{"$f":"VLOOKUP($A37,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Het rapport is grotendeels kernachtig en duidelijk gepresenteerd."},{"$f":"VLOOKUP($A37,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Het rapport is volledig kernachtig en duidelijk gepresenteerd."},{"$f":"VLOOKUP($A37,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},{"$nulls":3},false,0,3,1]
[]
[null,"Beslissing P6-K1-W3"]
[null,"Cijfertabel"]
[null,"Punten","Cijfer","Behaald"]
[null,0,{"$f":"ROUNDUP(IF(B42<$B$8,4.5/$B$8*B42+1,4.5/($B$4-$B$8)*(B42-$B$8)+5.5),1)","v":{"v":1,"d":"1.0"}},{"$f":"IF($B42=$B$5,\"X\",\"\")","v":"X"}]
[null,1,{"v":1.4000000000000001,"d":"1.4"},""]
[null,2,{"v":1.7000000000000002,"d":"1.7"},""]
[null,3,{"v":2,"d":"2.0"},""]
[null,4,{"v":2.3000000000000003,"d":"2.3"},""]
[null,5,2.7,""]
[null,6,{"v":3,"d":"3.0"},""]
[null,7,{"v":3.3000000000000003,"d":"3.3"},""]
[null,8,3.6,""]
[null,9,3.9,""]
[null,10,4.3,""]
[null,11,4.6,""]
[null,12,{"v":4.8999999999999995,"d":"4.9"},""]
[null,13,{"v":5.199999999999999,"d":"5.2"},""]
[null,14,5.5,""]
[null,15,{"v":5.8999999999999995,"d":"5.9"},""]
[null,16,{"v":6.199999999999999,"d":"6.2"},""]
[null,17,6.5,""]
[null,18,6.8,""]
[null,19,{"v":7.199999999999999,"d":"7.2"},""]
[null,20,7.5,""]
[null,21,7.8,""]
[null,22,8.1,""]
[null,23,8.4,""]
[null,24,{"v":8.799999999999999,"d":"8.8"},""]
[null,25,9.1,""]
[null,26,9.4,""]
[null,27,9.7,""]
[null,28,{"v":10,"d":"10.0"},""]
[null,{"$f":"IF(D42=\"X\",\"\",IF(D43=\"X\",C43,IF(D44=\"X\",C44,IF(D45=\"X\",C45,IF(D46=\"X\",C46,IF(D47=\"X\",C47,IF(D48=\"X\",C48,IF(D49=\"X\",C49,IF(D50=\"X\",C50,IF(D51=\"X\",C51,IF(D52=\"X\",C52,IF(D53=\"X\",C53,IF(D54=\"X\",C54,IF(D55=\"X\",C55,IF(D56=\"X\",C56,IF(D57=\"X\",C57,IF(D58=\"X\",C58,IF(D59=\"X\",C59,IF(D60=\"X\",C60,IF(D61=\"X\",C61,IF(D62=\"X\",C62,IF(D63=\"X\",C63,IF(D64=\"X\",C64,IF(D65=\"X\",C65,IF(D66=\"X\",C66,IF(D67=\"X\",C67,IF(D68=\"X\",C68,IF(D69=\"X\",C69,IF(D70=\"X\",C70,\"\")))))))))))))))))))))))))))))","v":""}]
[]
[null,"Motivatie"]
[null,"Motiveer de beslissing."]
[null,"Doe dit volgens richtlijnen van de school. Het is raadzaam om in elk geval een onvoldoende te motiveren.\nBij de motivering kan gebruik gemaakt worden van de beschrijvingen in de beoordelingstabel.\n"]
[]
[]
[null,"Authenticiteit"]
[null,"(Alleen invullen bij examenportfolio)"]
[null,"Het ingeleverde werk is authentiek (eigen werk)."]